package jpa.entitys.synchro.staging;

import java.io.Serializable;

import javax.persistence.*;

import java.util.Date;


/**
 * The persistent class for the FI_LIV_OUTGOINGPAYMENT_INB database table.
 * 
 */
@Entity
@Table(name="FI_LIV_OUTGOINGPAYMENT_INB")
@NamedQueries({
    @NamedQuery(name = "FiLivOutgoingpaymentInb.findAll", query = " SELECT c FROM FiLivOutgoingpaymentInb c "),
    @NamedQuery(name = "FiLivOutgoingpaymentInb.findById", query = " SELECT c FROM FiLivOutgoingpaymentInb c WHERE  c.promisStagingId = :Id "),
    @NamedQuery(name = "FiLivOutgoingpaymentInb.findIsSync", query = " SELECT c FROM FiLivOutgoingpaymentInb c WHERE  c.issync = :issync  order by c.instanceNo asc"),
    @NamedQuery(name = "FiLivOutgoingpaymentInb.findByInstanceNo", query = " SELECT c FROM FiLivOutgoingpaymentInb c WHERE c.instanceNo = :instanceNo order by c.promisStagingId asc"),
    @NamedQuery(name = "FiLivOutgoingpaymentInb.findByRequestNo", query = " SELECT c FROM FiLivOutgoingpaymentInb c WHERE c.sapPlantCode = :sapPlantCode And c.requestNo = :requestNo And c.status = :status And c.instanceNo = :instanceNo order by c.promisStagingId asc"),
    @NamedQuery(name = "FiLivOutgoingpaymentInb.findBySAPDocumentNo", query = " SELECT c FROM FiLivOutgoingpaymentInb c WHERE c.extRefNo = :extRefNo And c.instanceNo = :instanceNo And c.issync = :issync order by c.promisStagingId asc"),
    @NamedQuery(name = "FiLivOutgoingpaymentInb.findBySAPDocumentNo1", query = " SELECT c FROM FiLivOutgoingpaymentInb c WHERE c.extRefNo = :extRefNo And c.instanceNo = :instanceNo And c.issync = :issync And c.sapPlantCode = :sapPlantCode order by c.promisStagingId asc")
    })
public class FiLivOutgoingpaymentInb extends jpa.entitys.synchro.common.CommonEntity implements Serializable {
	private static final long serialVersionUID = 1L;

	@Id
	@Column(name="PROMIS_STAGING_ID", unique=true, nullable=false, length=100)
	private String promisStagingId;

	@Override public String toString() { return org.apache.commons.lang.builder.ToStringBuilder.reflectionToString(this);}
	
	@Column(name="ACTION_HANDLER")
	private String actionHandler;

	@Column(name="BUILDING_PHASE")
	private String buildingPhase;

	@Column(name="CHEQUE_DATE")
	private String chequeDate;

	@Column(name="COMPANY_CODE")
	private String companyCode;

	@Column(name="CONTRACT_REF_NO")
	private String contractRefNo;

	@Column(name="CONTRACT_REF_SERIES")
	private String contractRefSeries;

	@Column(name="CONTRACT_REF_TYPE")
	private String contractRefType;

	@Column(name="CREATED_BY")
	private String createdBy;

	@Column(name="CREATED_ON")
	private String createdOn;	

	@Column(name="DOCUMENT_REQUEST_NO")
	private String documentRequestNo;

	@Column(name="EXT_REF_KEY")
	private String extRefKey;

	@Column(name="EXT_REF_NO")
	private String extRefNo;

	@Column(name="INSTALLMENT_NUMBER")
	private String installmentNumber;

	@Column(name="INSTANCE_NO")
	private String instanceNo;

	@Column(name="ISACTIVE")
	private String isactive;

	@Column(name="ISSYNC")
	private String issync;

	@Column(name="MSG_ACT_RESULT")
	private String msgActResult;

	@Column(name="MSG_ALT_DESC")
	private String msgAltDesc;

	@Column(name="MSG_CODE")
	private String msgCode;

	@Column(name="MSG_DESC")
	private String msgDesc;

	@Column(name="PAYMENT_AMOUNT")
	private String paymentAmount;

	private String project;

	@Column(name="REQUEST_NO")
	private String requestNo;

	@Column(name="REQUEST_SERIES")
	private String requestSeries;

	@Column(name="REQUEST_TYPE")
	private String requestType;

	@Column(name="SAP_COMPANY_CODE")
	private String sapCompanyCode;

	@Column(name="SAP_PLANT_CODE")
	private String sapPlantCode;

	@Column(name="SEQ")
	private String seq;

	@Column(name="SEQ_NO")
	private long seqNo;

	@Column(name="STATUS")
	private String status;

	@Column(name="SYNC_CREATEDBY")
	private String syncCreatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_CREATEDON")
	private Date syncCreatedon;

	@Column(name="SYNC_UPDATEDBY")
	private String syncUpdatedby;

    @Temporal( TemporalType.TIMESTAMP)
	@Column(name="SYNC_UPDATEDON")
	private Date syncUpdatedon;

	@Column(name="UNIT_NUMBER")
	private String unitNumber;

	@Column(name="UPDATED_BY")
	private String updatedBy;

	@Column(name="UPDATED_ON")
	private String updatedOn;

	@Column(name="ZONE_CODE")
	private String zoneCode;
	
	@Column(name="DOCUMENT_DATE")
	private String documentDate;
	
	@Column(name="REF_DOC_CONTRACT_NO")
	private String refDocContractNo;
	
	@Column(name="INTERFACE_NO")
	private String interfaceNo;
	
	@Column(name="PAYMENT_DEDUC_AMOUNT")
	private String paymentDeducAmount;
	
	@Column(name="INSTALLMENT_NUMBER_STR")
	private String installmentNumberSrt;
	
	@Column(name="CONT_UNIT_SEQ")
	private String contUnitSeq;
	
	@Column(name="LINE_INST_KEY")
	private String lineInstKey;	
	
    /**
	 * @return the lineInstKey
	 */
	public String getLineInstKey() {
		return lineInstKey;
	}

	/**
	 * @param lineInstKey the lineInstKey to set
	 */
	public void setLineInstKey(String lineInstKey) {
		this.lineInstKey = lineInstKey;
	}
	
	/**
	 * @return the installmentNumberSrt
	 */
	public String getInstallmentNumberSrt() {
		return installmentNumberSrt;
	}

	/**
	 * @param installmentNumberSrt the installmentNumberSrt to set
	 */
	public void setInstallmentNumberSrt(String installmentNumberSrt) {
		this.installmentNumberSrt = installmentNumberSrt;
	}

	/**
	 * @return the contUnitSeq
	 */
	public String getContUnitSeq() {
		return contUnitSeq;
	}

	/**
	 * @param contUnitSeq the contUnitSeq to set
	 */
	public void setContUnitSeq(String contUnitSeq) {
		this.contUnitSeq = contUnitSeq;
	}

	public String getPaymentDeducAmount() {
		return paymentDeducAmount;
	}

	public void setPaymentDeducAmount(String paymentDeducAmount) {
		this.paymentDeducAmount = paymentDeducAmount;
	}

	public String getPromisStagingId() {
		return promisStagingId;
	}

	public void setPromisStagingId(String promisStagingId) {
		this.promisStagingId = promisStagingId;
	}

	public String getActionHandler() {
		return actionHandler;
	}

	public void setActionHandler(String actionHandler) {
		this.actionHandler = actionHandler;
	}

	public String getBuildingPhase() {
		return buildingPhase;
	}

	public void setBuildingPhase(String buildingPhase) {
		this.buildingPhase = buildingPhase;
	}

	public String getChequeDate() {
		return chequeDate;
	}

	public void setChequeDate(String chequeDate) {
		this.chequeDate = chequeDate;
	}

	public String getCompanyCode() {
		return companyCode;
	}

	public void setCompanyCode(String companyCode) {
		this.companyCode = companyCode;
	}

	public String getContractRefNo() {
		return contractRefNo;
	}

	public void setContractRefNo(String contractRefNo) {
		this.contractRefNo = contractRefNo;
	}

	public String getContractRefSeries() {
		return contractRefSeries;
	}

	public void setContractRefSeries(String contractRefSeries) {
		this.contractRefSeries = contractRefSeries;
	}

	public String getContractRefType() {
		return contractRefType;
	}

	public void setContractRefType(String contractRefType) {
		this.contractRefType = contractRefType;
	}

	public String getCreatedBy() {
		return createdBy;
	}

	public void setCreatedBy(String createdBy) {
		this.createdBy = createdBy;
	}

	public String getCreatedOn() {
		return createdOn;
	}

	public void setCreatedOn(String createdOn) {
		this.createdOn = createdOn;
	}

	public String getDocumentRequestNo() {
		return documentRequestNo;
	}

	public void setDocumentRequestNo(String documentRequestNo) {
		this.documentRequestNo = documentRequestNo;
	}

	public String getExtRefKey() {
		return extRefKey;
	}

	public void setExtRefKey(String extRefKey) {
		this.extRefKey = extRefKey;
	}

	public String getExtRefNo() {
		return extRefNo;
	}

	public void setExtRefNo(String extRefNo) {
		this.extRefNo = extRefNo;
	}

	public String getInstallmentNumber() {
		return installmentNumber;
	}

	public void setInstallmentNumber(String installmentNumber) {
		this.installmentNumber = installmentNumber;
	}

	public String getInstanceNo() {
		return instanceNo;
	}

	public void setInstanceNo(String instanceNo) {
		this.instanceNo = instanceNo;
	}

	public String getIsactive() {
		return isactive;
	}

	public void setIsactive(String isactive) {
		this.isactive = isactive;
	}

	public String getIssync() {
		return issync;
	}

	public void setIssync(String issync) {
		this.issync = issync;
	}

	public String getMsgActResult() {
		return msgActResult;
	}

	public void setMsgActResult(String msgActResult) {
		this.msgActResult = msgActResult;
	}

	public String getMsgAltDesc() {
		return msgAltDesc;
	}

	public void setMsgAltDesc(String msgAltDesc) {
		this.msgAltDesc = msgAltDesc;
	}

	public String getMsgCode() {
		return msgCode;
	}

	public void setMsgCode(String msgCode) {
		this.msgCode = msgCode;
	}

	public String getMsgDesc() {
		return msgDesc;
	}

	public void setMsgDesc(String msgDesc) {
		this.msgDesc = msgDesc;
	}

	public String getPaymentAmount() {
		return paymentAmount;
	}

	public void setPaymentAmount(String paymentAmount) {
		this.paymentAmount = paymentAmount;
	}

	public String getProject() {
		return project;
	}

	public void setProject(String project) {
		this.project = project;
	}

	public String getRequestNo() {
		return requestNo;
	}

	public void setRequestNo(String requestNo) {
		this.requestNo = requestNo;
	}

	public String getRequestSeries() {
		return requestSeries;
	}

	public void setRequestSeries(String requestSeries) {
		this.requestSeries = requestSeries;
	}

	public String getRequestType() {
		return requestType;
	}

	public void setRequestType(String requestType) {
		this.requestType = requestType;
	}

	public String getSapCompanyCode() {
		return sapCompanyCode;
	}

	public void setSapCompanyCode(String sapCompanyCode) {
		this.sapCompanyCode = sapCompanyCode;
	}

	public String getSapPlantCode() {
		return sapPlantCode;
	}

	public void setSapPlantCode(String sapPlantCode) {
		this.sapPlantCode = sapPlantCode;
	}

	public String getSeq() {
		return seq;
	}

	public void setSeq(String seq) {
		this.seq = seq;
	}

	public long getSeqNo() {
		return seqNo;
	}

	public void setSeqNo(long seqNo) {
		this.seqNo = seqNo;
	}

	public String getStatus() {
		return status;
	}

	public void setStatus(String status) {
		this.status = status;
	}

	public String getSyncCreatedby() {
		return syncCreatedby;
	}

	public void setSyncCreatedby(String syncCreatedby) {
		this.syncCreatedby = syncCreatedby;
	}

	public Date getSyncCreatedon() {
		return syncCreatedon;
	}

	public void setSyncCreatedon(Date syncCreatedon) {
		this.syncCreatedon = syncCreatedon;
	}

	public String getSyncUpdatedby() {
		return syncUpdatedby;
	}

	public void setSyncUpdatedby(String syncUpdatedby) {
		this.syncUpdatedby = syncUpdatedby;
	}

	public Date getSyncUpdatedon() {
		return syncUpdatedon;
	}

	public void setSyncUpdatedon(Date syncUpdatedon) {
		this.syncUpdatedon = syncUpdatedon;
	}

	public String getUnitNumber() {
		return unitNumber;
	}

	public void setUnitNumber(String unitNumber) {
		this.unitNumber = unitNumber;
	}

	public String getUpdatedBy() {
		return updatedBy;
	}

	public void setUpdatedBy(String updatedBy) {
		this.updatedBy = updatedBy;
	}

	public String getUpdatedOn() {
		return updatedOn;
	}

	public void setUpdatedOn(String updatedOn) {
		this.updatedOn = updatedOn;
	}

	public String getZoneCode() {
		return zoneCode;
	}

	public void setZoneCode(String zoneCode) {
		this.zoneCode = zoneCode;
	}

	public String getDocumentDate() {
		return documentDate;
	}

	public void setDocumentDate(String documentDate) {
		this.documentDate = documentDate;
	}

	public String getRefDocContractNo() {
		return refDocContractNo;
	}

	public void setRefDocContractNo(String refDocContractNo) {
		this.refDocContractNo = refDocContractNo;
	}

	public String getInterfaceNo() {
		return interfaceNo;
	}

	public void setInterfaceNo(String interfaceNo) {
		this.interfaceNo = interfaceNo;
	}	
	
	

}